<!DOCTYPE html>
<html lang="en-us">
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    
<meta charset="UTF-8">
<title>MicroStrategy Desktop | Elasticsearch Guide [7.7] | Elastic</title>
<link rel="home" href="index.html" title="Elasticsearch Guide [7.7]">
<link rel="up" href="sql-client-apps.html" title="SQL Client Applications">
<link rel="prev" href="sql-client-apps-ps1.html" title="Microsoft PowerShell">
<link rel="next" href="sql-client-apps-qlik.html" title="Qlik Sense Desktop">
<meta name="DC.type" content="Learn/Docs/Elasticsearch/Reference/7.7">
<meta name="DC.subject" content="Elasticsearch">
<meta name="DC.identifier" content="7.7">
<meta name="robots" content="noindex,nofollow">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <script src="https://cdn.optimizely.com/js/18132920325.js"></script>
    <link rel="apple-touch-icon" sizes="57x57" href="/apple-icon-57x57.png">
    <link rel="apple-touch-icon" sizes="60x60" href="/apple-icon-60x60.png">
    <link rel="apple-touch-icon" sizes="72x72" href="/apple-icon-72x72.png">
    <link rel="apple-touch-icon" sizes="76x76" href="/apple-icon-76x76.png">
    <link rel="apple-touch-icon" sizes="114x114" href="/apple-icon-114x114.png">
    <link rel="apple-touch-icon" sizes="120x120" href="/apple-icon-120x120.png">
    <link rel="apple-touch-icon" sizes="144x144" href="/apple-icon-144x144.png">
    <link rel="apple-touch-icon" sizes="152x152" href="/apple-icon-152x152.png">
    <link rel="apple-touch-icon" sizes="180x180" href="/apple-icon-180x180.png">
    <link rel="icon" type="image/png" href="/favicon-32x32.png" sizes="32x32">
    <link rel="icon" type="image/png" href="/android-chrome-192x192.png" sizes="192x192">
    <link rel="icon" type="image/png" href="/favicon-96x96.png" sizes="96x96">
    <link rel="icon" type="image/png" href="/favicon-16x16.png" sizes="16x16">
    <link rel="manifest" href="/manifest.json">
    <meta name="apple-mobile-web-app-title" content="Elastic">
    <meta name="application-name" content="Elastic">
    <meta name="msapplication-TileColor" content="#ffffff">
    <meta name="msapplication-TileImage" content="/mstile-144x144.png">
    <meta name="theme-color" content="#ffffff">
    <meta name="naver-site-verification" content="936882c1853b701b3cef3721758d80535413dbfd">
    <meta name="yandex-verification" content="d8a47e95d0972434">
    <meta name="localized" content="true">
    <meta name="st:robots" content="follow,index">
    <meta property="og:image" content="https://www.elastic.co/static/images/elastic-logo-200.png">
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
    <link rel="icon" href="/favicon.ico" type="image/x-icon">
    <link rel="apple-touch-icon-precomposed" sizes="64x64" href="/favicon_64x64_16bit.png">
    <link rel="apple-touch-icon-precomposed" sizes="32x32" href="/favicon_32x32.png">
    <link rel="apple-touch-icon-precomposed" sizes="16x16" href="/favicon_16x16.png">
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <link rel="stylesheet" type="text/css" href="/guide/static/styles.css">
  </head>

  <!--© 2015-2021 Elasticsearch B.V. Copying, publishing and/or distributing without written permission is strictly prohibited.-->

  <body>
    <!-- Google Tag Manager -->
    <script>dataLayer = [];</script><noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-58RLH5" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
    <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= '//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-58RLH5');</script>
    <!-- End Google Tag Manager -->

    <!-- Global site tag (gtag.js) - Google Analytics -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-12395217-16"></script>
    <script>
      window.dataLayer = window.dataLayer || [];
      function gtag(){dataLayer.push(arguments);}
      gtag('js', new Date());
      gtag('config', 'UA-12395217-16');
    </script>

    <!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->
    <script type="text/javascript">
      (function(){var g=function(e,h,f,g){
      this.get=function(a){for(var a=a+"=",c=document.cookie.split(";"),b=0,e=c.length;b<e;b++){for(var d=c[b];" "==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};
      this.set=function(a,c){var b="",b=new Date;b.setTime(b.getTime()+6048E5);b="; expires="+b.toGMTString();document.cookie=a+"="+c+b+"; path=/; "};
      this.check=function(){var a=this.get(f);if(a)a=a.split(":");else if(100!=e)"v"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(":"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case "v":return!1;case "r":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(":")),!c}return!0};
      this.go=function(){if(this.check()){var a=document.createElement("script");a.type="text/javascript";a.src=g;document.body&&document.body.appendChild(a)}};
      this.start=function(){var a=this;window.addEventListener?window.addEventListener("load",function(){a.go()},!1):window.attachEvent&&window.attachEvent("onload",function(){a.go()})}};
      try{(new g(100,"r","QSI_S_ZN_emkP0oSe9Qrn7kF","https://znemkp0ose9qrn7kf-elastic.siteintercept.qualtrics.com/WRSiteInterceptEngine/?Q_ZID=ZN_emkP0oSe9Qrn7kF")).start()}catch(i){}})();
    </script><div id="ZN_emkP0oSe9Qrn7kF"><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>
    <!--END WEBSITE FEEDBACK SNIPPET-->

    <div id="elastic-nav" style="display:none;"></div>
    <script src="https://www.elastic.co/elastic-nav.js"></script>

    <!-- Subnav -->
    <div>
      <div>
        <div class="tertiary-nav d-none d-md-block">
          <div class="container">
            <div class="p-t-b-15 d-flex justify-content-between nav-container">
              <div class="breadcrum-wrapper"><span><a href="/guide/" style="font-size: 14px; font-weight: 600; color: #000;">Docs</a></span></div>
            </div>
          </div>
        </div>
      </div>
    </div>

    <div class="main-container">
      <section id="content">
        <div class="content-wrapper">

          <section id="guide" lang="en">
            <div class="container">
              <div class="row">
                <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                  <!-- start body -->
                  <div class="page_header">
<strong>IMPORTANT</strong>: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
<a href="../current/index.html">current release documentation</a>.
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-link"><a href="sql-client-apps.html">SQL Client Applications</a></span>
»
<span class="breadcrumb-node">MicroStrategy Desktop</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-client-apps-ps1.html">« Microsoft PowerShell</a>
</span>
<span class="next">
<a href="sql-client-apps-qlik.html">Qlik Sense Desktop »</a>
</span>
</div>
<div class="section xpack">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-client-apps-microstrat"></a>MicroStrategy Desktop<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a><a class="xpack_tag" href="/subscriptions"></a>
</h2>
</div></div></div>
<p>You can use the Elasticsearch ODBC driver to access Elasticsearch data from MicroStrategy Desktop.</p>
<div class="important admon">
<div class="icon"></div>
<div class="admon_content">
<p>Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.</p>
</div>
</div>
<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_prerequisites_6"></a>Prerequisites<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a>
</h3>
</div></div></div>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a href="https://www.microstrategy.com/us/get-started/desktop" class="ulink" target="_top">MicroStrategy Desktop</a> 11 or higher
</li>
<li class="listitem">
Elasticsearch SQL <a class="xref" href="sql-odbc.html" title="SQL ODBC">ODBC driver</a>
</li>
<li class="listitem">
A preconfigured User or System DSN (see <a class="xref" href="sql-odbc-setup.html#dsn-configuration" title="2. Configure a DSN">Configuration</a> section on how to configure a DSN).
</li>
</ul>
</div>
</div>

<div class="section">
<div class="titlepage"><div><div>
<h3 class="title">
<a id="_data_loading_2"></a>Data loading<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/endpoints/client-apps/microstrat.asciidoc">edit</a>
</h3>
</div></div></div>
<p>To use the Elasticsearch SQL ODBC Driver to load data into MicroStrategy Desktop perform the following steps in sequence.</p>
<div class="olist orderedlist">
<ol class="orderedlist">
<li class="listitem">
<p>Create a New Dossier</p>
<p>Once the application is launched, you’ll first need to create a <em>New Dossier</em>:</p>
<p><a id="apps_microstrat_newdossier"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_newdossier.png" alt="apps microstrat newdossier"></span></p>
</li>
<li class="listitem">
<p>New Data</p>
<p>To import into the <em>New Dossier</em> just opened, press on the <em>New Data</em> button in the <em>DATASETS</em> column:</p>
<p><a id="apps_microstrat_newdata"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_newdata.png" alt="apps microstrat newdata"></span></p>
</li>
<li class="listitem">
<p>Access data from Tables</p>
<p>This opens a new window that allows to choose the source to load data from. Click on the <em>Databases</em> icon:</p>
<p><a id="apps_microstrat_databases"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_databases.png" alt="apps microstrat databases"></span></p>
</li>
<li class="listitem">
<p>New Data Source</p>
<p>In the newly opened <em>Import from Table - Select</em> window, click on the <span class="strong strong"><strong>+</strong></span> button to the right of <em>DATA SOURCES</em> item:</p>
<p><a id="apps_microstrat_newds"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_newds.png" alt="apps microstrat newds"></span></p>
</li>
<li class="listitem">
<p>Data Source</p>
<p>In the <em>Data Source</em> window, tick the radio button for <em>DSN Data Sources</em>. In the <em>DSN</em> drop-down box, choose the name of the DSN that you
have previously configured. For the <em>Version</em>, chose <em>Generic DBMS</em>.</p>
<p>Input a user name and password in the provided fields.
Note that the application requires them irrespective of the fact that they might already be part of the previously configured DSN and the
new input will take precedence over those.</p>
<p>Finally, give a name to the application-specific data source you’re just configuring:</p>
<p><a id="apps_microstrat_dsn"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_dsn.png" alt="apps microstrat dsn"></span></p>
</li>
<li class="listitem">
<p>Select Import Options</p>
<p>Choosing an import methodology follows. You can pick any of the options; we’ll exemplify the <em>Select Tables</em> option:</p>
<p><a id="apps_microstrat_tables"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_tables.png" alt="apps microstrat tables"></span></p>
</li>
<li class="listitem">
<p>Import from Table - Select</p>
<p>The data source you’ve named two steps before is now listed in the <em>DATA SOURCES</em> column. Clicking on its name triggers the
application to query the Elasticsearch instance configured in the DSN and list the tables available within:</p>
<p><a id="apps_microstrat_loadtable"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_loadtable.png" alt="apps microstrat loadtable"></span></p>
</li>
<li class="listitem">
<p>Data Access Mode</p>
<p>Choose a table to load data from and press the <em>Finish</em> button. When doing so, the application offers to choose a loading methodology.
You can choose whichever, we’ll exemplify the <em>Connect Live</em> way:</p>
<p><a id="apps_microstrat_live"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_live.png" alt="apps microstrat live"></span></p>
</li>
<li class="listitem">
<p>Visualize the data</p>
<p>From the <em>DATASETS</em> column you can choose what table columns (or index fields) to visualize:</p>
<p><a id="apps_microstrat_visualize"></a><span class="image"><img src="images/sql/odbc/apps_microstrat_visualize.png" alt="apps microstrat visualize"></span></p>
</li>
</ol>
</div>
</div>

</div>
<div class="navfooter">
<span class="prev">
<a href="sql-client-apps-ps1.html">« Microsoft PowerShell</a>
</span>
<span class="next">
<a href="sql-client-apps-qlik.html">Qlik Sense Desktop »</a>
</span>
</div>
</div>

                  <!-- end body -->
                </div>
                <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                  <div id="rtpcontainer" style="display: block;">
                    <div class="mktg-promo">
                      <h3>Most Popular</h3>
                      <ul class="icons">
                        <li class="icon-elasticsearch-white"><a href="https://www.elastic.co/webinars/getting-started-elasticsearch?baymax=default&amp;elektra=docs&amp;storm=top-video">Get Started with Elasticsearch: Video</a></li>
                        <li class="icon-kibana-white"><a href="https://www.elastic.co/webinars/getting-started-kibana?baymax=default&amp;elektra=docs&amp;storm=top-video">Intro to Kibana: Video</a></li>
                        <li class="icon-logstash-white"><a href="https://www.elastic.co/webinars/introduction-elk-stack?baymax=default&amp;elektra=docs&amp;storm=top-video">ELK for Logs &amp; Metrics: Video</a></li>
                      </ul>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </section>

        </div>


<div id="elastic-footer"></div>
<script src="https://www.elastic.co/elastic-footer.js"></script>
<!-- Footer Section end-->

      </section>
    </div>

<script src="/guide/static/jquery.js"></script>
<script type="text/javascript" src="/guide/static/docs.js"></script>
<script type="text/javascript">
  window.initial_state = {}</script>
  </body>
</html>
